﻿
namespace StagingAreaETL
{
    class StudentDIM
    {
        internal StudentDIM(int natKey1, string aisID, int? fieldOfStudyKey, string firstName, string lastName, int? grade)
        {
            NaturalKEY_1 = natKey1;
            AIS_id = aisID;
            FieldOfStudyKEY = fieldOfStudyKey;
            FirstName = firstName;
            LastName = lastName;
            Grade = grade;
        }

        internal int NaturalKEY_1;                      //natural PK taken from SA.STUDENT
        internal int NaturalKEY_2 { get; set; }         //natural PK taken from SA.LIB_STUDENT
        internal int SurrogateKEY { get; set; }         //field 'StudentKEY'. To be assigned on INSERT as auto-increment

        internal readonly string AIS_id;
        internal readonly int? FieldOfStudyKEY;
        internal int? StudyStatusKEY { get; set;}
        internal readonly string FirstName;
        internal readonly string LastName;
        internal readonly int? Grade;
    }
}
